﻿DECLARE @img VARBINARY(MAX)

SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\AC Ajaccio.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='AC Ajaccio';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Toulouse FC.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Toulouse FC';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\AS Nancy Lorraine.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='AS Nancy Lorraine';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\LOSC Lille Métropole.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='LOSC Lille Métropole';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Girondins de Bordeaux.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Girondins de Bordeaux';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\AS Saint-Etienne.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='AS Saint-Etienne';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Stade Brestois 29.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Stade Brestois 29';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Evian TG FC.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Evian TG FC';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\SM Caen.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='SM Caen';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Valenciennes FC.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Valenciennes FC';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Dijon FCO.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Dijon FCO';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Stade Rennais FC.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Stade Rennais FC';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Olympique de Marseille.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Olympique de Marseille';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\FC Sochaux Montbeliard.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='FC Sochaux Montbeliard';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Montpellier Hérault SC.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Montpellier Hérault SC';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\AJ Auxerre.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='AJ Auxerre';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\OGC Nice.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='OGC Nice';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Olympique Lyonnais.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Olympique Lyonnais';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\Paris Saint-Germain.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='Paris Saint-Germain';

GO

DECLARE @img VARBINARY(MAX)
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK 'C:\temp\FC Lorient.png', SINGLE_BLOB) AS x

update [ParieurProDB].dbo.Teams Set [ParieurProDB].dbo.Teams.Icon=@img
where [ParieurProDB].dbo.Teams.Name='FC Lorient';


GO
